Unable to import wiki data - WARNING: SET LOCAL can only be used in transaction blocks

Question

Level 1

9 points

Unable to import wiki data - WARNING: SET LOCAL can only be used in transaction blocks

I'm trying to use the wikiadmin tool to export all wikis from one server, and then import them onto another server, both on OS X El Capitan.

I can export the wikis fine from the first server

sudo wikiadmin export -all -path wikis

I then copy the exported files over to the second server and try to import them into the wiki

sudo wikiadmin import -all -path wikis/

The output is this message, about 31,000 times:

WARNING:  SET LOCAL can only be used in transaction blocks

There are no other errors, but nothing in the wiki on the second server changes.

Googling suggests it's related to PostgreSQL, but I haven't been able to find any suggestions on how to fix it. Any ideas on what to do next?

Mac mini, OS X Mavericks (10.9.1)

Posted on Jul 7, 2016 8:08 AM

Reply

Answer 1

Mar 13, 2017 2:08 PM in response to Infoserve

Hi there - sorry for resurrecting an old thread; but I'm running into the same issue. At the end of the import process, and a bunch of the 'Set Local' warnings, I receive:

Error: Caught top-level exception: [PGCQueryError] Error executing query

Followed by what I would imagine is a PG query with SELECT and FROM fields.

Reply

Answer 2

Linc Davis

Level 10

209,739 points

Jul 7, 2016 9:32 AM in response to Infoserve

Apple has not documented a way to migrate Wiki data in the current version of OS X. I haven't tested this unofficial procedure, but there's no obvious reason why it wouldn't work.

Reply

Answer 3

Infoserve Author

Level 1

9 points

Jul 15, 2016 4:44 AM in response to Linc Davis

Hi Linc,

Thanks for the reply. I followed the link you posted by that didn't work unfortunately. When looking through the database there's nothing with a create_time more recent than 2015, so it looks like the "wikiadmin import" didn't actually import anything.

I don't know if there's anything else to try, as you mentioned there's not much documentation on migrating Apple Wikis.

Reply